Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ColorCode (PK) | A code to identify the color. The assumption is that the retailer will adopt the standards as designated by the NRF, created to facilitate the exchange of data between vendors and retailers | CD_CLR | Code4 | char(4) | |
Name | The individual names of the associated colors that are encompassed by the respective color code. For example, color code 201 may include both chocolate and kola nut. | NM_CLR | Name | varchar(40) | |
Description | A full description of the individual color, designated by the respective code and name. | DE_CLR | DescriptionShort | varchar(255) | |
ColorPaletteID (FK) | A unique retailer assigned identifier for the ColorPalette. | ID_PLTE_CLR | Identity | integer | ColorPalette(CO_PLTE_CLR) |
ColorListAgencyID (FK) | A unique retailer assigned identifier for the ColorListAgency that provides Color definitions to the retailer. | ID_AGY_CLR_LST | Identity | integer | ColorListAgency(PA_AGY_CLR_LST) |
Modification | Changes the main color description (e.g. Green) to include Avocado or Dinosaur to convey a marketing message. May also contain other color-based Style modifiers, e.g. for Milk Chocolate the modifier could be White vs. Dark; for Ladies' Watches the modifier could be Pink Band vs. Blue Band | DE_MDFR | DescriptionShort | varchar(255) | |